SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 41755: SAS® ODBC Driver does not appear in the ODBC Data Source Administrator Drivers Tab

DetailsAboutRate It

The SAS ODBC driver does not appear in the ODBC Data Source Administrator Drivers Tab because the SAS 9.2 Server is running 64-bit and the SAS ODBC driver is 32-bit.

On x64 Windows platforms, the operating system keeps track of 32-bit and 64-bit data sources in different places. If you use the ODBC Administrator in the Control Panel to set up the data source, it is using 64-bit drivers and storing the data source in the 64-bit location.

If you are using a 32-bit application, then you have to launch the administrator (odbcad32.exe) from the C:\WINDOWS\SysWOW64 directory. Creating a System DSN in this location should allow the user to see the data source in 32-bit SAS.

 



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS Drivers for ODBCMicrosoft® Windows® for x649.2 TS2M39.3 TS1M2
Microsoft Windows Server 2003 Datacenter Edition9.2 TS2M39.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition9.2 TS2M39.3 TS1M2
Microsoft Windows Server 2003 Standard Edition9.2 TS2M39.3 TS1M2
Microsoft Windows Server 2003 for x649.2 TS2M39.3 TS1M2
Microsoft Windows Server 20089.2 TS2M39.3 TS1M2
Microsoft Windows Server 2008 for x649.2 TS2M39.3 TS1M2
Microsoft Windows XP Professional9.2 TS2M39.3 TS1M2
Windows 7 Enterprise 32 bit9.2 TS2M39.3 TS1M2
Windows 7 Enterprise x649.2 TS2M39.3 TS1M2
Windows 7 Home Premium 32 bit9.2 TS2M39.3 TS1M2
Windows 7 Home Premium x649.2 TS2M39.3 TS1M2
Windows 7 Professional 32 bit9.2 TS2M39.3 TS1M2
Windows 7 Professional x649.2 TS2M39.3 TS1M2
Windows 7 Ultimate 32 bit9.2 TS2M39.3 TS1M2
Windows 7 Ultimate x649.2 TS2M39.3 TS1M2
Windows Vista9.2 TS2M39.3 TS1M2
Windows Vista for x649.2 TS2M39.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.